package com.abvnet.project.water.project.mapper;

import com.abvnet.project.water.project.domain.ProjectMicrobial;
import java.util.List;	

/**
 * 菌剂 数据层
 * 
 * @author duj
 * @date 2019-07-02
 */
public interface ProjectMicrobialMapper {
	/**
     * 查询菌剂信息
     * 
     * @param microbialId 菌剂ID
     * @return 菌剂信息
     */
	public ProjectMicrobial selectProjectMicrobialById(Long microbialId);
	
	/**
     * 查询菌剂列表
     * 
     * @param projectMicrobial 菌剂信息
     * @return 菌剂集合
     */
	public List<ProjectMicrobial> selectProjectMicrobialList(ProjectMicrobial projectMicrobial);

	public List<ProjectMicrobial> selectProjectMicrobialListByType(ProjectMicrobial projectMicrobial);

	public List<ProjectMicrobial> selectListForApi();

    List<ProjectMicrobial> selectMicrobialListByPlanId(Long planId);

    List<ProjectMicrobial> selectUnMicrobialListByPlanId(Long planId);

	/**
     * 新增菌剂
     * 
     * @param projectMicrobial 菌剂信息
     * @return 结果
     */
	public int insertProjectMicrobial(ProjectMicrobial projectMicrobial);
	
	/**
     * 修改菌剂
     * 
     * @param projectMicrobial 菌剂信息
     * @return 结果
     */
	public int updateProjectMicrobial(ProjectMicrobial projectMicrobial);
	
	/**
     * 删除菌剂
     * 
     * @param microbialId 菌剂ID
     * @return 结果
     */
	public int deleteProjectMicrobialById(Long microbialId);
	
	/**
     * 批量删除菌剂
     * 
     * @param microbialIds 需要删除的数据ID
     * @return 结果
     */
	public int deleteProjectMicrobialByIds(String[] microbialIds);
	
}